Mega Code Archive
Table
1) Add Index and primary key to a table in table creation command
2) Add primary key to a table by using the alter table command
3) Add Unique constaints to cover two columns
4) Add unique constraint to a table using the alter table command
5) ADDing a Column
6) Adding Columns
7) ALTER [IGNORE] TABLE table_name specification [,specification]
8) ALTER TABLE Employee ADD (KEY) myIndex (id)
9) ALTER TABLE Employee DROP INDEX lastn_idx
10) ALTER TABLE Employee DROP KEY lastn_idx
11) ALTER TABLE table_name ADD (KEYINDEX) index_name (column_name[, ])
12) ALTER TABLE table_name ADD PRIMARY KEY index_name (column_name[, ])
13) ALTER TABLE table_name ADD UNIQUE index_name (column_name[, ])
14) Alter table to add an index on two columns
15) Alter table to add the foreign key
16) Alter table to drop primary key and foreign key
17) Auto_INCREMENT primary key
18) Changing a Column Name
19) Changing a Column Type
20) Character Sets and Collations in MySQL
21) Character_set_system
22) Check the created table by issuing a describe command
23) Choose partial key in table creation
24) Column Character Set and Collation
25) Column Modifiers
26) Composite Partial Keys
27) Copy a table by using the create select from
28) Copy a table with Create Select statement
29) Create a table by UNION another table
30) CREATE INDEX index_name ON table_name (column_name[, ])
31) Create primary key after column definition
32) Create primary key in column definition
33) CREATE TABLE table_name (column_name field_type [NULLNOT NULL],KEY col_index(column_name))
34) CREATE UNIQUE INDEX [index_name] ON table_name (column_name[, ])
35) Creating a Table with an Index
36) Creating an Index
37) Creating an Index with the ALTER TABLE Statement
38) Creating table with Foreign key
39) Creating Tables with AUTO_INCREMENT and NOT NULL column
40) Database, Table, and Column Definition with Character and collate
41) Deleting Indexes
42) Drop primary key from a table using the alter table command
43) Drop table column with alter table command
44) DROP-ing Columns and Tables
45) Dropping Tables
46) Every database has a database character set and a database collation
47) For a multiple-row insert, LAST_INSERT_ID() returns the AUTO_INCREMENT key from the first of the inserted rows
48) FOREIGN KEY ON DELETE CASCADE ON UPDATE CASCADE
49) IF NOT EXISTS parameter can be used to check if a table exists before you actually create it
50) Implement a many-to-many map
51) List the available character set
52) Making copy of the table with auto_increment column in one statement
53) MODIFYing a TABLE
54) Multiple-Column Keys
55) Multiple-Column Primary Keys
56) One table with two foreign keys
57) Partial Keys
58) Primary Keys
59) Remove the data from the original table using a TRUNCATE statement
60) Renaming a Table
61) Server Character Set and Collation
62) SHOW CREATE DATABASE displays the CREATE DATABASE statement that creates a given database
63) SHOW CREATE TABLE displays the CREATE TABLE statement to create a given table
64) SHOW INDEX FROM Employee
65) SHOW KEYS FROM Employee Table
66) Table and Column Definition with character and collate
67) Table Character Set and Collation
68) Temporary Tables
69) TEXT CHARACTER SET latin1 COLLATE latin1_bin
70) The CHARACTER SET attribute specifies the character set, and the COLLATE attribute specifies a collation for the character set
71) The output from SHOW COLLATION includes all available character sets
72) The Short Way to copy a table with auto_increment column
73) The SHOW CHARACTER SET command shows all available character sets
74) The SHOW COLUMNS statement displays the collations of a tables columns when invoked as SHOW FULL COLUMNS
75) The syntax for creating a table
76) To delete a column from a table
77) To drop a PRIMARY KEY
78) To drop a table column
79) To remove a primary key
80) To remove the whole table
81) To start with an AUTO_INCREMENT value other than 1
82) To verify the table structure, use a DESCRIBE statement
83) TYPE=MYISAM
84) Unique Keys
85) Use a CREATE TABLE statement to specify the layout of your table
86) Use Auto_increment column as part of the key
87) Use partial indexing as the primary key
88) Use two columns as the combined primary key
89) Using a query to create the temporary table
90) Using alter command to change characgter set
91) Using AUTO_INCREMENT
92) Using Foreign Keys
93) Using Indexes
94) Using the ALTER TABLE statement to add an index
95) Using the default key word to insert value
96) You can create more than one unique key
97) You can retrieve the most recent AUTO_INCREMENT value with the LAST_INSERT_ID()